use MicroStrategy_Views
select    distinct a11.ItemNumber02  ItemNumber02,
                a11.ItemNumber  ItemNumber,
                a11.Description01  Description01,
                a11.L1_Code  L1_Code,
                a11.L1  UserDefinedCodesValues,
                a11.L2_Code  L2_Code,
                a11.L2  UserDefinedCodesValues0,
                a11.L3_Code  L3_Code,
                a11.L3  UserDefinedCodesValues1,
                a11.L4_Code  L4_Code,
                a11.L4  UserDefinedCodesValues2,
                a11.SalesCategory01Code  SalesCategory01Code,
                a11.SalesCategory01  SalesCategory01,
                a11.SalesCategory02Code  SalesCategory02Code,
                a11.SalesCategory02  SalesCategory02,
                a11.SalesCategory03Code  SalesCategory03Code,
                a11.SalesCategory03  SalesCategory03,
                a11.SalesCategory04Code  SalesCategory04Code,
                a11.SalesCategory04  SalesCategory04
from      Common_Star_Item      a11
where   (a11.L1_Code <> 'EQP'
 and a11.ItemNumber02 = '120007')


use RD_CommonWORK
select 
L3_FINISHED_GOODS_CODE,	L3_FINISHED_GOODS FROM dbo.ITEM_SUPPLEMENTAL
where
ITEMNUMBER='35487'


use tempdb
select * FROM dbo.#ZZT2NHMHIZSMD000


sp_who